| Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
StudentAcademicYearId |
|
INTEGER |
NO |
|
StudentEnrollmentPeriodId |
|
INTEGER |
NO |
|
| AcademicYearId |
|
INTEGER |
NO |
|
| ProgramVersionAcademicYearId |
|
INTEGER |
NO |
|
| GradeLevelId |
|
INTEGER |
NO |
|
BudgetId |
|
INTEGER |
YES |
|
| Sequence |
|
SMALLINT |
NO |
|
| FaAdvisorId |
|
INTEGER |
YES |
|
| StartDate |
|
DATETIME |
NO |
|
| EndDate |
|
DATETIME |
NO |
|
| FirstAwardYear |
|
CHAR(7) |
NO |
|
| SecondAwardYear |
|
CHAR(7) |
YES |
|
| IsFirstTimeBorrower |
|
BIT |
NO |
|
| PackageDate |
|
DATETIME |
YES |
|
PackagingStatusId |
|
INTEGER |
NO |
|
| IsPackageRevised |
|
BIT |
NO |
|
| AwardNoticePrintedDate |
|
DATETIME |
YES |
|
| AwardNoticeSigned |
|
DATETIME |
YES |
|
| RevisedAwardNoticePrinted |
|
DATETIME |
YES |
|
| RevisedAwardNoticeSigned |
|
DATETIME |
YES |
|
| WeeksInAcademicYear |
|
NUMERIC(4, 1) |
YES |
|
| MonthsIncademicYear |
|
NUMERIC(4, 1) |
YES |
|
| WeeksNonEnrollment |
|
NUMERIC(4, 1) |
YES |
|
| CreditHoursInAcademicYear |
|
NUMERIC(7, 2) |
YES |
|
| CostOfAttendance |
|
MONEY(19, 4) |
YES |
|
| Tuition |
|
MONEY(19, 4) |
YES |
|
| BooksSupplies |
|
MONEY(19, 4) |
YES |
|
| RoomBoard |
|
MONEY(19, 4) |
YES |
|
| Travel |
|
MONEY(19, 4) |
YES |
|
| OtherCostDescription1 |
|
VARCHAR(40) |
YES |
|
| OtherCostAmount1 |
|
MONEY(19, 4) |
YES |
|
| OtherCostDescription2 |
|
VARCHAR(40) |
YES |
|
| OtherCostAmount2 |
|
MONEY(19, 4) |
YES |
|
| OtherCostDescription3 |
|
VARCHAR(40) |
YES |
|
| OtherCostAmount3 |
|
MONEY(19, 4) |
YES |
|
| OtherCostDescription4 |
|
VARCHAR(40) |
YES |
|
| OtherCostAmount4 |
|
MONEY(19, 4) |
YES |
|
| PellCostOfAttendance |
|
MONEY(19, 4) |
YES |
|
| WeeksEnrolledInAcademicYear |
|
INTEGER |
YES |
|
| CreditHoursExpectedToComplete |
|
NUMERIC(9, 2) |
YES |
|
| Note |
|
VARCHAR(4000) |
YES |
|
| BilledDate |
|
DATETIME |
YES |
|
| LastModifiedUserId |
|
INTEGER |
NO |
|
| CreatedDateTime |
|
DATETIME |
NO |
|
| LastModifiedDateTime |
|
DATETIME |
NO |
|
| RowVersion |
|
TIMESTAMP/DATE |
NO |
|
| InstitutionalCharges |
|
MONEY(19, 4) |
YES |
|
| PackagingMethodId |
|
INTEGER |
YES |
|
| OtherCostAmount5 |
|
MONEY(19, 4) |
YES |
|
| OtherCostAmount6 |
|
MONEY(19, 4) |
YES |
|
| OtherCostAmount7 |
|
MONEY(19, 4) |
YES |
|
| OtherCostAmount8 |
|
MONEY(19, 4) |
YES |
|
| OtherCostDescription5 |
|
CHAR(40) |
YES |
|
| OtherCostDescription6 |
|
CHAR(40) |
YES |
|
| OtherCostDescription7 |
|
CHAR(40) |
YES |
|
| OtherCostDescription8 |
|
CHAR(40) |
YES |
|
| IsOtherCostInstitutionalCharge1 |
|
BIT |
NO |
|
| IsOtherCostInstitutionalCharge2 |
|
BIT |
NO |
|
| IsOtherCostInstitutionalCharge3 |
|
BIT |
NO |
|
| IsOtherCostInstitutionalCharge4 |
|
BIT |
NO |
|
| IsOtherCostInstitutionalCharge5 |
|
BIT |
NO |
|
| IsOtherCostInstitutionalCharge6 |
|
BIT |
NO |
|
| IsOtherCostInstitutionalCharge7 |
|
BIT |
NO |
|
| IsOtherCostInstitutionalCharge8 |
|
BIT |
NO |
|
| AcYrNote |
|
VARCHAR(3000) |
YES |
|
| LenderFees |
|
MONEY(19, 4) |
NO |
|
| BudgetRecordIdentifier |
|
CHAR(20) |
YES |
|
| PackagedToEnrollmentStatusId |
|
INTEGER |
YES |
|
| HousingStatusCode |
|
CHAR(1) |
YES |
|
| IsHybridDates |
|
BIT |
NO |
|
SecondAwardYearPackagingStatusId |
|
INTEGER |
YES |
|
| IsUnsubEligibilityUpToHeal |
|
BIT |
NO |
|
| TeachCounselingDate |
|
DATETIME |
YES |
|
| IsUnsupportedDependent |
|
BIT |
NO |
|
| IsAutoAwardBudgetLock |
|
BIT |
NO |
|
| IsAutoAwardPackageLock |
|
BIT |
NO |
|
| AutoAwardEvaluationType |
|
CHAR(1) |
YES |
|
| AutoAwardRequestProcess |
|
VARCHAR(200) |
YES |
|
| HPPALevel |
|
CHAR(1) |
NO |
|
| PLUSCreditDecisionStatus |
|
CHAR(1) |
YES |
|
| IsSummerPackagingExcluded |
|
BIT |
NO |
|
AutoAwardConfigurationId |
|
INTEGER |
YES |
|
| AutoAwardInitialCalculationDate |
|
DATETIME |
YES |
|
| AutoAwardRepackageCalculationDate |
|
DATETIME |
YES |
|
| IsReentryAcademicYear |
|
BIT |
YES |
|
| IsStartDateExcluded |
|
BIT |
NO |
|
| IsEndDateExcluded |
|
BIT |
NO |
|
| CounselingCompleteDate |
|
DATETIME |
YES |
|
| CounselingType |
|
VARCHAR(50) |
YES |
|
AutoAwardEnrollmentStatusId |
|
INTEGER |
YES |
|
| IWINAY |
|
NUMERIC(4, 1) |
NO |
|
| IWMonths |
|
NUMERIC(4, 1) |
NO |
|
| RefWeeksInAcademicYear |
|
NUMERIC(4, 1) |
YES |
|
| RefCreditHoursInAcademicYear |
|
NUMERIC(7, 2) |
YES |
|
| TermsToPackageDirectLoan |
|
VARCHAR(max) |
NO |
|
| Key Name |
Key Type |
Keys |
| FaStudentAY_AwardYear1_N_N_IDX |
Inversion Entry |
FirstAwardYear |
| NK_FaStudentAY_FirstTimeBorrower_INCL |
Inversion Entry |
IsFirstTimeBorrower |
| Nk_FaStudentAyAutoAwardAdAttStatId |
Inversion Entry |
AutoAwardEnrollmentStatusId |
| NK_FaStudentAYStartDate |
Inversion Entry |
StartDate |
| FaStudentAY_FaPackStatusID_N_N_IDX |
Inversion Entry |
PackagingStatusId |
| FaStudentAY_FaBudgetID_N_N_IDX |
Inversion Entry |
BudgetId |
| FaStudentAY_StartDate_PackageDate_N_N_IDX |
Inversion Entry |
StartDate, PackageDate |
| FaStudentAY_FaProgramAYSeqID_N_N_IDX |
Inversion Entry |
ProgramVersionAcademicYearId |
| FaStudentAY_AwardYear2_N_N_IDX |
Inversion Entry |
SecondAwardYear |
| Nk_FaStudentAy_AdEnrollID_FaPackStatusID_FaAutoAwardPopulationConfigurationId |
Inversion Entry |
AutoAwardConfigurationId |
| Nk_FaStudentAyFaAutoAwardPopulationConfigurationId |
Inversion Entry |
AutoAwardConfigurationId |
| FaStudentAY_EndDate_N_N_IDX |
Inversion Entry |
EndDate |
| FaStudentAY_BudGetRecordId_N_N_IDX |
Inversion Entry |
BudgetRecordIdentifier |
| FaStudentAY_FAStudentAYID_U_C_IDX |
PrimaryKey |
StudentAcademicYearId |
| FaStudentAY_AdEnrollID_Sequence_N_N_IDX |
Inversion Entry |
StudentEnrollmentPeriodId, Sequence |
| FaStudentAY_StartDate_EndDate_FaPackStatusID_AdEnrollID_N_N_IDX |
Inversion Entry |
StartDate, EndDate, PackagingStatusId, StudentEnrollmentPeriodId |
| FaStudentAY_AdEnrollID_N_N_IDX |
Inversion Entry |
StudentEnrollmentPeriodId |